
. local sumt   = 1;

. local eq     = 1;

. *****************************************;
. * Table 2                               *;
. * Make the primary summary stats table  *;
. *****************************************;
. if `sumt' {;
.  **************;
.  * Town Stats *;
.  **************;
.  use house_restat, clear;
.  *********************************************;
.  * restrict to the sample used in estimation *;
.  *********************************************;
.   keep if admr_200;
(1194 observations deleted)
.   drop if nhid == 744;
(15 observations deleted)
.   * Hanover;
.   drop if nhid == 843;
(0 observations deleted)
.   * Orford;
.   drop if nhid == 2009;
(15 observations deleted)
.  * Seabrook - dropped due to uncertainty surrounding the taxing of the nuclear power plant;
.     for num 89 91 93 95 97 99 101 103 : drop if year == X;

->  drop if year == 89
(0 observations deleted)

->  drop if year == 91
(161 observations deleted)

->  drop if year == 93
(161 observations deleted)

->  drop if year == 95
(161 observations deleted)

->  drop if year == 97
(161 observations deleted)

->  drop if year == 99
(161 observations deleted)

->  drop if year == 101
(161 observations deleted)

->  drop if year == 103
(161 observations deleted)
.   drop if year > 100;
(322 observations deleted)
.   by nhid : egen c = count(c_l_ass_sch_rtot);
.   tab c;

          c |      Freq.     Percent        Cum.
------------+-----------------------------------
          4 |          6        0.62        0.62
          5 |        960       99.38      100.00
------------+-----------------------------------
      Total |        966      100.00
.   gen balance = (c == 5);
.   keep if balance;
(6 observations deleted)
.  ********************************************************;
.  * define some variables and make some required changes *;
.  ********************************************************;
.     * There are several versions of the tax rate variable.  The table uses the total tax rate variable obtained from the VAL spreadsheets.;
.   * This is the optimal series because it reflects the different property tax bases for the different taxes - i.e. local educ, state educ;
.   * and other local.;
.   capture drop ltax_rate;
.   gen ltax_rate = v_tratee_tot;
(640 missing values generated)
.   * recode c_eqval so as to make it readable on the table;
.   replace c_eqval = c_eqval / 1000000;
(960 real changes made)
.   bysort nhid : egen donor = sum((cg_excess > 0) * (year == 100));
.   replace c_edg_snp_rtot = . if edgrant == 0;
(816 real changes made, 816 to missing)
.   replace c_exc_rtot     = . if c_exc_rtot == 0;
(944 real changes made, 944 to missing)
.   bysort nhid : egen rectown = sum((c_edg_snp_rtot ~= .) * (year == 100));
.   local sumlist1 = "sf3_hai donor nomeet sbtown";
.   local sumlist2 = "spop adm_rtot c_l_ass_sch_rtot c_edg_snp_rtot c_exc_rtot c_eqval ltax_rate";
.   local sumlist3 = "ltax_rate";
.  *******************************************************************;
.  * create local macros containing values to be displayed on table  *;
.  *******************************************************************;
.    foreach c in `sumlist1' {;
  2.    sum `c' if year == 100;
  3.    local m_100_`c' = round(r(mean), .0001);
  4.    local s_100_`c' = round(r(sd)  , .0001);
  5.     local n_100_`c' = r(N);
  6.   };

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
     sf3_hai |       160    62339.44    16217.29   35240.99   127647.2

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
       donor |       160          .1    .3009419          0          1

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
      nomeet |       160       .0625    .2428215          0          1

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
      sbtown |       160         .25    .4343722          0          1
.   foreach b in 98 100 {;
  2.    foreach c in `sumlist2' {;
  3.     sum `c'  if year == `b', det;
  4.     local m_`b'_`c'   = round(r(mean ), .0001);
  5.     local s_`b'_`c'   = round(r(sd)   , .0001);
  6.     local n_100_`c' = r(N);
  7.    };
  8.   };

                            spop
-------------------------------------------------------------
      Percentiles      Smallest
 1%     1274.313       1229.375
 5%         1433       1274.313
10%     1576.406           1295       Obs                 160
25%     2103.313       1317.438       Sum of Wgt.         160

50%      3878.75                      Mean           7075.524
                        Largest       Std. Dev.      11872.52
75%     6657.844       33367.75
90%     14176.13       40080.94       Variance       1.41e+08
95%     23310.75          85099       Skewness       5.640733
99%        85099       104696.9       Kurtosis       41.53408

                       (sum) adm_rtot
-------------------------------------------------------------
      Percentiles      Smallest
 1%        205.7          201.3
 5%       260.15          205.7
10%       279.65          239.2       Obs                 160
25%       361.55          240.3       Sum of Wgt.         160

50%        676.6                      Mean           1169.974
                        Largest       Std. Dev.      1778.537
75%      1175.05           5462
90%       2305.1           6517       Variance        3163194
95%       4151.6        12818.9       Skewness       5.094021
99%      12818.9        14810.8       Kurtosis       34.77112

                      c_l_ass_sch_rtot
-------------------------------------------------------------
      Percentiles      Smallest
 1%     2717.015       1931.495
 5%     3665.124       2717.015
10%      4602.57       3063.466       Obs                 160
25%     5375.087       3179.748       Sum of Wgt.         160

50%     6165.649                      Mean           6287.304
                        Largest       Std. Dev.      1517.327
75%     7092.628       9678.007
90%     8187.298       10049.08       Variance        2302282
95%     9104.409        10794.3       Skewness       .2960828
99%      10794.3       11256.27       Kurtosis       3.823595

                       c_edg_snp_rtot
-------------------------------------------------------------
no observations

                         c_exc_rtot
-------------------------------------------------------------
no observations

                           c_eqval
-------------------------------------------------------------
      Percentiles      Smallest
 1%      52.4337       51.00504
 5%     65.55257        52.4337
10%     82.26807       54.89289       Obs                 160
25%     122.2479       55.04373       Sum of Wgt.         160

50%     196.2105                      Mean           394.9286
                        Largest       Std. Dev.      573.8421
75%     425.5181       1806.488
90%     928.2681       2097.958       Variance       329294.8
95%     1319.998       4024.162       Skewness       4.389197
99%     4024.162       4476.697       Kurtosis       27.64923

                          ltax_rate
-------------------------------------------------------------
      Percentiles      Smallest
 1%         9.84           9.28
 5%       15.975           9.84
10%       18.175          10.08       Obs                 160
25%        23.16          11.03       Sum of Wgt.         160

50%       27.545                      Mean            27.1655
                        Largest       Std. Dev.      6.578719
75%        32.04          38.11
90%        34.69          40.22       Variance       43.27955
95%       36.415          41.62       Skewness      -.2776014
99%        41.62          46.44       Kurtosis       3.055709

                            spop
-------------------------------------------------------------
      Percentiles      Smallest
 1%         1297           1273
 5%         1478           1297
10%         1622           1329       Obs                 160
25%         2183           1331       Sum of Wgt.         160

50%       4052.5                      Mean           7267.863
                        Largest       Std. Dev.      12121.04
75%       6801.5          34021
90%      14497.5          40687       Variance       1.47e+08
95%      24177.5          86605       Skewness       5.626585
99%        86605         107006       Kurtosis       41.42452

                       (sum) adm_rtot
-------------------------------------------------------------
      Percentiles      Smallest
 1%        223.5          167.3
 5%       254.85          223.5
10%        277.6            230       Obs                 160
25%        364.1          250.7       Sum of Wgt.         160

50%        723.9                      Mean           1198.861
                        Largest       Std. Dev.      1825.895
75%       1188.8         5445.8
90%      2373.35         6801.8       Variance        3333892
95%       4205.2        13178.7       Skewness       5.094606
99%      13178.7        15183.9       Kurtosis       34.75574

                      c_l_ass_sch_rtot
-------------------------------------------------------------
      Percentiles      Smallest
 1%     1928.156       1834.568
 5%     2929.207       1928.156
10%      3282.81       2374.649       Obs                 160
25%     4200.437       2578.346       Sum of Wgt.         160

50%     4953.319                      Mean           5459.027
                        Largest       Std. Dev.      1977.256
75%     6492.006        9773.03
90%     8029.303       11958.27       Variance        3909543
95%     9354.952       12220.03       Skewness       1.126659
99%     12220.03       13299.79       Kurtosis       4.777596

                       c_edg_snp_rtot
-------------------------------------------------------------
      Percentiles      Smallest
 1%     155.5694       19.29479
 5%     557.1371       155.5694
10%      864.808       176.2384       Obs                 144
25%     1318.849       258.5224       Sum of Wgt.         144

50%     1741.868                      Mean           1631.746
                        Largest       Std. Dev.      545.1197
75%     2018.618       2567.677
90%     2207.328       2608.704       Variance       297155.5
95%     2334.652        2631.58       Skewness      -.7580467
99%      2631.58       2663.046       Kurtosis       3.327376

                         c_exc_rtot
-------------------------------------------------------------
      Percentiles      Smallest
 1%     20.69987       20.69987
 5%     20.69987       108.8602
10%     108.8602       245.7587       Obs                  16
25%     410.9791       373.9712       Sum of Wgt.          16

50%     885.5728                      Mean           1547.993
                        Largest       Std. Dev.       1622.87
75%     2561.276       3253.045
90%     3656.971       3621.283       Variance        2633707
95%     5552.073       3656.971       Skewness       1.178234
99%     5552.073       5552.073       Kurtosis       3.302503

                           c_eqval
-------------------------------------------------------------
      Percentiles      Smallest
 1%     59.18718       58.69744
 5%     79.88335       59.18718
10%     91.98363       59.27234       Obs                 160
25%     140.3713       63.97253       Sum of Wgt.         160

50%     239.3681                      Mean           468.6283
                        Largest       Std. Dev.      697.9384
75%     474.9547       2398.312
90%     1032.455       2462.906       Variance         487118
95%     1627.549       4938.771       Skewness       4.371467
99%     4938.771       5354.505       Kurtosis       27.24176

                          ltax_rate
-------------------------------------------------------------
      Percentiles      Smallest
 1%        10.86           9.51
 5%       14.975          10.86
10%        16.32          11.49       Obs                 160
25%       18.265          11.84       Sum of Wgt.         160

50%        21.02                      Mean           21.68262
                        Largest       Std. Dev.       4.86875
75%       24.345          32.98
90%       28.035          35.67       Variance       23.70473
95%       30.695          36.03       Skewness       .4946162
99%        36.03          36.64       Kurtosis       3.630703
.   foreach b in 98 100 {;
  2.    foreach c in `sumlist3' {;
  3.     sum `c'  if year == `b', det;
  4.     local m_`b'_`c'   = round(r(mean ), .0001);
  5.     local s_`b'_`c'   = round(r(sd)   , .0001);
  6.     local r10_`b'_`c' = round(r(p10)  , .0001);
  7.     local r90_`b'_`c' = round(r(p90)  , .0001);
  8.     local lr91_`b'_`c'= log(r(p90)) - log(r(p10));
  9.       local cv_`b'_`c'   = r(sd)/r(mean);
 10.      local n_`b'_`c'   = r(N);
 11.    };
 12.    };

                          ltax_rate
-------------------------------------------------------------
      Percentiles      Smallest
 1%         9.84           9.28
 5%       15.975           9.84
10%       18.175          10.08       Obs                 160
25%        23.16          11.03       Sum of Wgt.         160

50%       27.545                      Mean            27.1655
                        Largest       Std. Dev.      6.578719
75%        32.04          38.11
90%        34.69          40.22       Variance       43.27955
95%       36.415          41.62       Skewness      -.2776014
99%        41.62          46.44       Kurtosis       3.055709

                          ltax_rate
-------------------------------------------------------------
      Percentiles      Smallest
 1%        10.86           9.51
 5%       14.975          10.86
10%        16.32          11.49       Obs                 160
25%       18.265          11.84       Sum of Wgt.         160

50%        21.02                      Mean           21.68262
                        Largest       Std. Dev.       4.86875
75%       24.345          32.98
90%       28.035          35.67       Variance       23.70473
95%       30.695          36.03       Skewness       .4946162
99%        36.03          36.64       Kurtosis       3.630703
.  *****************;
.  * School Stats  *;
.  *****************;
.   use dis_restat, clear;
.   drop if d_nhid == 126;
(15 observations deleted)
.   * Orford;
.   drop if d_nhid == 65;
(15 observations deleted)
.    * Hanover;
.   drop if d_nhid == 146;
(15 observations deleted)
.   * Seabrook;
.    * restrict to districts with at least 200 students in 1998;
.   bysort d_nhid : egen v33_200  = sum((v33 > 200)  * year == 98);
.   keep if v33_200;
(706 observations deleted)
.   keep if year == 98 | year == 100;
(1615 observations deleted)
.    by d_nhid : egen net = sum((v33_c_edg_plt_sn - v33_c_exc_plt) * (year == 100));
.    gen v33_c_tcurelsc_pnet = v33_c_tcurelsc_l * (net > 0);
.   gen v33_c_tcurelsc_nnet = v33_c_tcurelsc_l * (net <= 0);
.   replace v33_c_tcurelsc_pnet = . if net <= 0;
(28 real changes made, 28 to missing)
.   replace v33_c_tcurelsc_nnet = . if net >  0;
(222 real changes made, 222 to missing)
.    local sumlistdis = "v33 v33_c_str_l v33_c_tcurelsc_l v33_c_tcurelsc_pnet v33_c_tcurelsc_nnet";
.  *******************************************************************;
.  * create local macros containing values to be displayed on table  *;
.  *******************************************************************;
.    foreach b in 98 100 {;
  2.    foreach c in `sumlistdis' {;
  3.     sum `c'     if year == `b', det;
  4.     local m_`b'_`c'   = round(r(mean), .0001);
  5.     local s_`b'_`c'   = round(r(sd)  , .0001);
  6.     local n_`b'_`c'   = r(N);
  7.    };
  8.    sum v33_c_tcurelsc_l if year == `b', det;
  9.     local m_`b'_v33_c_tcurelsc_l    = round(r(mean ), .0001);
 10.    local s_`b'_v33_c_tcurelsc_l    = round(r(sd)   , .0001);
 11.    local n_`b'_v33_c_tcurelsc_l    = r(N);
 12.    local lr91_`b'_v33_c_tcurelsc_l = log(r(p90)) - log(r(p10));
 13.      local cv_`b'_v33_c_tcurelsc_l   = r(sd)/r(mean);
 14.   };

                             V33
-------------------------------------------------------------
      Percentiles      Smallest
 1%          214            214
 5%          227            214
10%          249            220       Obs                 125
25%          483            223       Sum of Wgt.         125

50%          938                      Mean           1567.768
                        Largest       Std. Dev.       2136.09
75%         1863           5222
90%         3151           5652       Variance        4562882
95%         4655          13449       Skewness       4.597768
99%        13449          16932       Kurtosis       29.98139

                         v33_c_str_l
-------------------------------------------------------------
      Percentiles      Smallest
 1%     137.6017       37.31237
 5%     167.9056       137.6017
10%     200.2009       152.3459       Obs                 125
25%     325.3353       153.4735       Sum of Wgt.         125

50%     601.7725                      Mean           761.9809
                        Largest       Std. Dev.      605.8668
75%     1034.989       2257.642
90%     1468.794       2619.243       Variance       367074.6
95%     1879.673       3180.144       Skewness        1.83099
99%     3180.144       3407.535       Kurtosis       7.197511

                      v33_c_tcurelsc_l
-------------------------------------------------------------
      Percentiles      Smallest
 1%     4875.158       4733.387
 5%     5240.477       4875.158
10%       5690.4       5017.469       Obs                 125
25%     6071.016       5105.576       Sum of Wgt.         125

50%     6802.824                      Mean           6916.325
                        Largest       Std. Dev.      1145.831
75%     7529.096       9438.252
90%     8667.659       9551.558       Variance        1312928
95%     9069.696       9636.631       Skewness       .5482835
99%     9636.631       9741.961       Kurtosis       2.656743

                     v33_c_tcurelsc_pnet
-------------------------------------------------------------
      Percentiles      Smallest
 1%     4875.158       4733.387
 5%     5227.774       4875.158
10%       5690.4       5017.469       Obs                 111
25%     5975.778       5105.576       Sum of Wgt.         111

50%     6659.536                      Mean           6758.279
                        Largest       Std. Dev.      1053.364
75%     7243.925       9069.696
90%     8260.092       9137.025       Variance        1109575
95%     8835.979       9636.631       Skewness       .6633758
99%     9636.631       9741.961       Kurtosis       3.148511

                     v33_c_tcurelsc_nnet
-------------------------------------------------------------
      Percentiles      Smallest
 1%     5648.318       5648.318
 5%     5648.318       6855.802
10%     6855.802       7303.595       Obs                  14
25%     7366.131       7366.131       Sum of Wgt.          14

50%      8396.59                      Mean           8169.403
                        Largest       Std. Dev.      1109.205
75%     9049.745       9049.745
90%     9438.252       9297.622       Variance        1230335
95%     9551.558       9438.252       Skewness      -.7252053
99%     9551.558       9551.558       Kurtosis       2.902149

                      v33_c_tcurelsc_l
-------------------------------------------------------------
      Percentiles      Smallest
 1%     4875.158       4733.387
 5%     5240.477       4875.158
10%       5690.4       5017.469       Obs                 125
25%     6071.016       5105.576       Sum of Wgt.         125

50%     6802.824                      Mean           6916.325
                        Largest       Std. Dev.      1145.831
75%     7529.096       9438.252
90%     8667.659       9551.558       Variance        1312928
95%     9069.696       9636.631       Skewness       .5482835
99%     9636.631       9741.961       Kurtosis       2.656743

                             V33
-------------------------------------------------------------
      Percentiles      Smallest
 1%          194            191
 5%          206            194
10%          256            195       Obs                 125
25%          521            196       Sum of Wgt.         125

50%         1020                      Mean           1597.264
                        Largest       Std. Dev.      2182.145
75%         1846           5419
90%         3227           5564       Variance        4761759
95%         4783          13668       Skewness       4.636535
99%        13668          17407       Kurtosis       30.44114

                         v33_c_str_l
-------------------------------------------------------------
      Percentiles      Smallest
 1%     56.89392       31.30327
 5%      140.854       56.89392
10%     345.8289        62.4958       Obs                 125
25%     1739.823       82.99879       Sum of Wgt.         125

50%     2383.982                      Mean           2309.708
                        Largest       Std. Dev.      1114.129
75%     3187.926       4022.215
90%     3506.983       4565.295       Variance        1241283
95%     3828.212       4569.412       Skewness      -.4276377
99%     4569.412       4885.436       Kurtosis       2.654473

                      v33_c_tcurelsc_l
-------------------------------------------------------------
      Percentiles      Smallest
 1%     5230.847       4980.216
 5%     5543.814       5230.847
10%     5995.526       5299.869       Obs                 125
25%     6435.988       5336.744       Sum of Wgt.         125

50%     7135.273                      Mean           7298.029
                        Largest       Std. Dev.      1171.264
75%     8099.255       9728.639
90%     9063.638       9762.778       Variance        1371859
95%     9274.256       9986.367       Skewness       .4086855
99%     9986.367       10194.53       Kurtosis       2.450874

                     v33_c_tcurelsc_pnet
-------------------------------------------------------------
      Percentiles      Smallest
 1%     5230.847       4980.216
 5%     5525.164       5230.847
10%     5910.127       5299.869       Obs                 111
25%     6295.372       5336.744       Sum of Wgt.         111

50%     6933.945                      Mean            7139.27
                        Largest       Std. Dev.      1098.027
75%     7907.437       9480.872
90%     8661.636       9686.044       Variance        1205664
95%     9214.521       9762.778       Skewness       .4970352
99%     9762.778       9986.367       Kurtosis        2.69664

                     v33_c_tcurelsc_nnet
-------------------------------------------------------------
      Percentiles      Smallest
 1%     6796.879       6796.879
 5%     6796.879       7172.293
10%     7172.293       7564.753       Obs                  14
25%     7912.438       7912.438       Sum of Wgt.          14

50%     8741.845                      Mean           8556.756
                        Largest       Std. Dev.      980.9069
75%     9215.563       9215.563
90%     9728.639       9274.256       Variance       962178.3
95%     10194.53       9728.639       Skewness      -.2111427
99%     10194.53       10194.53       Kurtosis       2.167246

                      v33_c_tcurelsc_l
-------------------------------------------------------------
      Percentiles      Smallest
 1%     5230.847       4980.216
 5%     5543.814       5230.847
10%     5995.526       5299.869       Obs                 125
25%     6435.988       5336.744       Sum of Wgt.         125

50%     7135.273                      Mean           7298.029
                        Largest       Std. Dev.      1171.264
75%     8099.255       9728.639
90%     9063.638       9762.778       Variance        1371859
95%     9274.256       9986.367       Skewness       .4086855
99%     9986.367       10194.53       Kurtosis       2.450874
.   *********************;
.  * display the stats *;
.  *********************;
.   foreach c in `sumlist1' {;
  2.    disp "XX XX `m_100_`c''";
  3.    disp "XX XX `s_100_`c''";
  4.    disp " ";
  5.   };
XX XX 62339.4414
XX XX 16217.2851
 
XX XX .1
XX XX .3009
 
XX XX .0625
XX XX .2428
 
XX XX .25
XX XX .4344
 
.   foreach c in `sumlist2' {;
  2.    disp "`m_98_`c'' XX `m_100_`c''";
  3.    disp "`s_98_`c'' XX `s_100_`c''";
  4.    disp " ";
  5.    if "`c'" == "ltax_rate" {;
  6.     disp "`lr91_98_ltax_rate' XX `lr91_100_ltax_rate'";
  7.     disp "`cv_98_ltax_rate'   XX `cv_100_ltax_rate'  ";
  8.     disp " ";
  9.    };
 10.   };
7075.5238 XX 7267.8625
11872.5197 XX 12121.0444
 
1169.9737 XX 1198.8606
1778.537 XX 1825.8949
 
6287.3037 XX 5459.027300000001
1517.3274 XX 1977.2565
 
. XX 1631.7464
. XX 545.1197000000001
 
. XX 1547.9926
. XX 1622.8701
 
394.9286 XX 468.6283
573.8421000000001 XX 697.9384
 
27.1655 XX 21.6826
6.5787 XX 4.8688
 
.6464044424628685 XX .5410623932964076
.2421718430776201   XX .2245461734894129  
 
.  disp "`n_98_c_l_ass_sch_rtot' `n_100_c_l_ass_sch_rtot'";
 160
.   foreach c in `sumlistdis' {;
  2.   disp "`m_98_`c'' XX `m_100_`c'' XX `mW_98_`c'' XX `mW_100_`c''";
  3.   disp "`s_98_`c'' XX `s_100_`c'' XX `sW_98_`c'' XX `sW_100_`c''";
  4.   disp " ";
  5.   if "`c'" == "v33_c_tcurelsc_l" {;
  6.     disp "`lr91_98_v33_c_tcurelsc_l' XX `lr91_100_v33_c_tcurelsc_l' XX `lr91W_98_v33_c_tcurelsc_l' XX `lr91W_100_v33_c_tcurelsc_l'";
  7.     disp "`cv_98_v33_c_tcurelsc_l'   XX `cv_100_v33_c_tcurelsc_l' XX `cvW_98_v33_c_tcurelsc_l'   XX `cvW_100_v33_c_tcurelsc_l'";
  8.     disp " ";
  9.   };
 10.  };
1567.768 XX 1597.264 XX  XX 
2136.0904 XX 2182.1454 XX  XX 
 
761.9809 XX 2309.7082 XX  XX 
605.8668 XX 1114.1287 XX  XX 
 
6916.3252 XX 7298.0289 XX  XX 
1145.8307 XX 1171.2639 XX  XX 
 
.4208181504460651 XX .4132570468781935 XX  XX 
.1656704511828232   XX .1604904474391269 XX    XX 
 
6758.2793 XX 7139.270500000001 XX  XX 
1053.3637 XX 1098.0273 XX  XX 
 
8169.402800000001 XX 8556.756000000001 XX  XX 
1109.2048 XX 980.9069000000001 XX  XX 
 
.  disp "`n_98_v33_c_str_l' `n_100_v33_c_str_l' ";
125 125 
. };

. ******************************************;
. * produce the fiscal equity calculations *;
. ******************************************;
. if `eq' {;
.  use house_restat, clear;
.  keep if admr_200;
(1194 observations deleted)
.  drop if nhid == 744;
(15 observations deleted)
.   * Hanover;
.  drop if nhid == 843;
(0 observations deleted)
.   * Orford;
.  drop if nhid == 2009;
(15 observations deleted)
.  * Seabrook - dropped due to uncertainty surrounding the taxing of the nuclear power plant;
.    keep if year == 98 | year == 100;
(2093 observations deleted)
.  * gen some required vars;
.  * using -.9 as the estimate of offset - this is in the middle of the range of estimates;
.  * dispersion vars;
.  bysort nhid : egen c_eqval98 = sum(c_eqval * (year == 98));
.  gen t_base_trate = ((((v_totptax)  * cpi) / c_eqval98) * 1000) if year == 98;
(161 missing values generated)
.  bysort nhid : egen base_trate = sum(t_base_trate * (year == 98));
.  gen post_trate = base_trate + (((-(c_edg_snp    * .9) + (c_exc)) / c_eqval98)*1000) if year == 100;
(161 missing values generated)
.  foreach g in base_trate post_trate {;
  2.   sum `g' if year == 100 & `g' ~= 0, det;
  3.   local m_`g'   = round(r(mean ), .0001);
  4.   local s_`g'   = round(r(sd)   , .0001);
  5.   local r10_`g' = round(r(p10)  , .0001);
  6.   local r90_`g' = round(r(p90)  , .0001);
  7.   local lr91_`g'= log(r(p90)) - log(r(p10));
  8.     local cv_`g'  = r(sd)/r(mean);
  9.   };

                         base_trate
-------------------------------------------------------------
      Percentiles      Smallest
 1%      9.84049        9.28073
 5%     16.24851        9.84049
10%     18.19308        10.0781       Obs                 161
25%     23.40476       11.03437       Sum of Wgt.         161

50%     27.59873                      Mean           27.15945
                        Largest       Std. Dev.      6.543945
75%     31.77308       38.10915
90%     34.67535       40.21579       Variance       42.82321
95%     36.28967       41.61632       Skewness      -.2840363
99%     41.61632       46.43837       Kurtosis       3.092036

                         post_trate
-------------------------------------------------------------
      Percentiles      Smallest
 1%     12.67953       12.13925
 5%     15.71695       12.67953
10%     17.35809       12.82559       Obs                 161
25%     19.22671       14.05664       Sum of Wgt.         161

50%      21.8968                      Mean           22.12153
                        Largest       Std. Dev.      4.214679
75%     24.64923       31.38092
90%     27.35287        31.5727       Variance       17.76352
95%     28.97382       32.81227       Skewness       .4361034
99%     32.81227       38.89962       Kurtosis       3.876964
.  * elasticity vars.;
.  bysort nhid : egen base_tax = sum((v_totptax * cpi) * (year == 98));
.  gen post_tax = base_tax - (c_edg_snp * .9) + (c_exc) if year == 100;
(161 missing values generated)
.  sum post_tax base_tax if year == 100;

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
    post_tax |       161     8595266    1.30e+07   954645.4   9.89e+07
    base_tax |       161    1.01e+07    1.56e+07    1493683   1.24e+08
.  for var base_tax post_tax : gen X_sp98 = X / spop98;

->  gen base_tax_sp98 = base_tax / spop98

->  gen post_tax_sp98 = post_tax / spop98
(161 missing values generated)
.  for var sf3_hai sf3_hmi base_tax_sp98 post_tax_sp98 : gen ln_X = ln(X);

->  gen ln_sf3_hai = ln(sf3_hai)

->  gen ln_sf3_hmi = ln(sf3_hmi)

->  gen ln_base_tax_sp98 = ln(base_tax_sp98)

->  gen ln_post_tax_sp98 = ln(post_tax_sp98)
(161 missing values generated)
.   ****************************************************************************;
.  * The log ratio and cv of the property tax - changes implied by the reform *;
.  ****************************************************************************;
.  disp "`lr91_base_trate' `lr91_post_trate'";
.64498803343885 .4547629849671382
.  disp "`cv_base_trate' `cv_post_trate'";
.2409453727041449 .1905238746751079
.  ************************************************;
.  * Elasticity of mean local tax wrt mean income *;
.  ************************************************;
.  reg ln_base_tax_sp98 ln_sf3_hai if year == 100 & admr_200 & nhid ~= 744 & nhid ~= 843 & nhid ~= 2009;

      Source |       SS       df       MS              Number of obs =     161
-------------+------------------------------           F(  1,   159) =   38.78
       Model |  1.73496011     1  1.73496011           Prob > F      =  0.0000
    Residual |  7.11394675   159  .044741803           R-squared     =  0.1961
-------------+------------------------------           Adj R-squared =  0.1910
       Total |  8.84890686   160  .055305668           Root MSE      =  .21152

------------------------------------------------------------------------------
ln_base_t~98 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
  ln_sf3_hai |   .4184534   .0671984     6.23   0.000     .2857368    .5511701
       _cons |   2.677926   .7398232     3.62   0.000     1.216778    4.139074
------------------------------------------------------------------------------
.  reg ln_post_tax_sp98 ln_sf3_hai if year == 100 & admr_200 & nhid ~= 744 & nhid ~= 843 & nhid ~= 2009;

      Source |       SS       df       MS              Number of obs =     161
-------------+------------------------------           F(  1,   159) =   43.74
       Model |  4.05465488     1  4.05465488           Prob > F      =  0.0000
    Residual |   14.739953   159  .092704107           R-squared     =  0.2157
-------------+------------------------------           Adj R-squared =  0.2108
       Total |  18.7946079   160  .117466299           Root MSE      =  .30447

------------------------------------------------------------------------------
ln_post_t~98 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
  ln_sf3_hai |   .6397044   .0967279     6.61   0.000     .4486671    .8307417
       _cons |   .0531591   1.064929     0.05   0.960    -2.050072     2.15639
------------------------------------------------------------------------------
. };

. log close;
      name:  <unnamed>
       log:  /lcl/fa/proj2/nh/work/post_Restat/nh_sum.log
  log type:  text
 closed on:  14 Dec 2010, 20:44:28
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
